package com.jiyun.play.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.domain.Play;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author lenovo
* @description 针对表【play】的数据库操作Mapper
* @createDate 2024-12-18 11:19:36
* @Entity generator.domain.Play
*/
@Mapper
public interface PlayMapper extends BaseMapper<Play> {
    @Select("select p.*,g.game_type as gamesType,g.image as gameImage from play p left join games g on p.gid = g.id")
    List<Play> fndALLPlay(Play play);
    @Select("select * from play where gid= ${id}")
    List<Play> findTab(Integer id);
//    @Select("select p.*,g.game_type as gamesType,g.image as gameImage from play p left join games g on p.gid = g.id where gid= ${gid}")
//    List<Play> findTabName(Integer gid);
}




